Re: OID order = INSERT order? - Mailing list pgsql-general

From Elaine Lindelef
Subject Re: OID order = INSERT order?
Date
Msg-id v04210110b9b545d04957@[172.16.2.101]
Whole thread Raw
In response to Re: OID order = INSERT order?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OID order = INSERT order?  (Roland Roberts <roland@astrofoto.org>)
List pgsql-general
>elein <elein@norcov.com> writes:
> > In 7.3b1, the oids of a row do not change on update
> > according to my experiment.  I had thought they did.
> > Is this new with 7.3?
>
>No, same as it ever was.
>
>            regards, tom lane

OIDs only change if you drop from a table and then reinsert the data.
Perhaps that is what you were thinking of?

Elaine Lindelef


pgsql-general by date:

Previous
From: Kevin Brannen
Date:
Subject: Re: query for non-unique values?
Next
From: Neil Conway
Date:
Subject: Re: Postgres 7.3b1 + JDBC3 (2002-09-05) truncates SQL commands?